SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_GetRequireByID] ( @JOL_Require_ID INT )
AS 
    SELECT  b.JOL_Employer_Name,
            a.JOL_Require_Job,
            a.JOL_Require_Work_Area,
            a.JOL_Require_Study_Level,
            a.JOL_Require_Profession,
            a.JOL_Require_Number,
            a.JOL_Require_GetJob_Type,
            a.JOL_Require_Linkman,
            a.JOL_Require_Contact,
            a.JOL_Require_EndTime,
            a.JOL_Require_Requirement,
            a.JOL_Require_Remark,
            a.JOL_Require_Student_Type,
            a.JOL_Require_ClickNumber,
            a.JOL_Require_AddTime,
            a.JOL_Require_AddUser,
            a.JOL_Require_UpdateTime,
            a.JOL_Require_UpdateUser,
            a.JOL_Require_VerifyStatus,
            a.JOL_Require_VerifyTime,
            a.JOL_Require_VerifyUser,
            a.OnlyForSysu
    FROM    dbo.JOL_Require AS a
            INNER JOIN dbo.JOL_Employer AS b ON a.JOL_Require_Company = b.JOL_Employer_Account
    WHERE   a.JOL_Require_ID = @JOL_Require_ID


GO
